Restoring a SQL Server vault to another server

A Meridian vault can be moved to another computer (for example, as a server upgrade) by restoring a backup of the vault made on the original server and by modifying the vault configuration file.

Warning    To move (by restoring from backup) a vault from a pre-Windows Server 2008 computer (including Windows XP, Windows Server 2000, or Windows Server 2003) to a post-Windows Server 2008 (including Windows Vista) or later computer, see Changing operating system versions.

Notes

• The following task assumes the Meridian vault is hosted on a dedicated SQL Server computer. For alternative environments, modify the paths accordingly.
• The paths specified must all exist prior to restoring the vault.
• The location \\<ServerShare>\BC-Meridian Vaults\<Vault>\Backup must be accessible (Full Control) from the SQL Server computer.
• The location specified for LocalDataPath is used heavily for write-ahead log files, so it should be high-performance. We recommend a local SSD drive.
• The location specified for BackupLocation does not need to be high-performance and can be on a network share, if desired.

To restore a SQL Server vault on another server:

1. On the original server, create a backup of the vault as described in Preparing for backups.
2. Edit the resulting DataStore.ini file in any text editor and change or add the following settings. For descriptions of each setting, see HKEY_LOCAL_MACHINE\Software\Cyco\AutoManager Meridian\CurrentVersion\Installed DataStores\<vaultname>\CompoundItemService and HKEY_LOCAL_MACHINE\Software\Cyco\AutoManager Meridian\CurrentVersion\Installed DataStores\<vaultname>\StreamService.
   • LocalDataPath=S_\\<ServerShare>\BC-Meridian Vaults\<Vault>
   • BackupLocation=S_\\<ServerShare>\BC-Meridian Vaults\<Vault>\Backup
   • Servername=S_<SQLServerName>\<SQLServerInstance>
   • DataPath=S_<SQLServerDrive>:\BC-Meridian Vaults\<Vault>
   • IndexPath=S_<SQLServerDrive>:\BC-Meridian Vaults\<Vault>
   • LogPath=S_<SQLServerDrive>:\BC-Meridian Vaults\<Vault>
   • RootPath=S_\\<ServerShare>\BC-Meridian Vaults\<Vault>
3. Copy the modified DataStore.ini file and the contents of the Backup folder from the old server to the new server location \\<ServerShare>\BC-Meridian Vaults\<Vault>\Backup.
4. Copy the vault streams folders from the old server to the new server location <ServerShare>\BC-Meridian Vaults\<Vault>.
5. On the new server, restore the vault using the modified DataStore.ini file as described in Restoring backups.